Tabela ImportGPS4SchoolPOZ

Definicja tabeli ImportGPS4SchoolPOZ

Name

ImportGPS4SchoolPOZ

Code

ImportGPS4SchoolPOZ

Comment

 


Lista kolumn tabeli ImportGPS4SchoolPOZ

Name

Code

ImportNo

ImportNo

Error

Error

Comment

Comment

LastName

LastName

FirstName

FirstName

NationalIDNo

NationalIDNo

IsForeigner

IsForeigner

Place

Place

AdmCode

AdmCode

PostalCode

PostalCode

Street

Street

HomeNo

HomeNo

FlatNo

FlatNo

StartDT

StartDT

DocLastName

DocLastName

DocFirstName

DocFirstName

LicenceNo

LicenceNo

DocNationalIDNo

DocNationalIDNo

CategoryGPID

CategoryGPID

StopDT

StopDT

SchoolFullName

SchoolFullName

SchoolKindID

SchoolKindID

CompanyStatisticalNo

CompanyStatisticalNo

PupilCategoryID

PupilCategoryID

isMilitaryServicePlace

isMilitaryServicePlace

isBaseOfPayment

isBaseOfPayment

IdentificationTypeID

IdentificationTypeID

IdentificationDocumentNo

IdentificationDocumentNo

FluoridePrevention

FluoridePrevention

ClassName

ClassName

InsertDate

InsertDate


Kolumna ImportNo tabeli ImportGPS4SchoolPOZ

Definicja kolumny ImportNo tabeli ImportGPS4SchoolPOZ

Name

ImportNo

Code

ImportNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Error tabeli ImportGPS4SchoolPOZ

Definicja kolumny Error tabeli ImportGPS4SchoolPOZ

Name

Error

Code

Error

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Comment tabeli ImportGPS4SchoolPOZ

Definicja kolumny Comment tabeli ImportGPS4SchoolPOZ

Name

Comment

Code

Comment

Data Type

VARCHAR2(100)

Mandatory

No

Comment

 


Kolumna LastName tabeli ImportGPS4SchoolPOZ

Definicja kolumny LastName tabeli ImportGPS4SchoolPOZ

Name

LastName

Code

LastName

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna FirstName tabeli ImportGPS4SchoolPOZ

Definicja kolumny FirstName tabeli ImportGPS4SchoolPOZ

Name

FirstName

Code

FirstName

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna NationalIDNo tabeli ImportGPS4SchoolPOZ

Definicja kolumny NationalIDNo tabeli ImportGPS4SchoolPOZ

Name

NationalIDNo

Code

NationalIDNo

Data Type

VARCHAR2(11)

Mandatory

No

Comment

 


Kolumna IsForeigner tabeli ImportGPS4SchoolPOZ

Definicja kolumny IsForeigner tabeli ImportGPS4SchoolPOZ

Name

IsForeigner

Code

IsForeigner

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Place tabeli ImportGPS4SchoolPOZ

Definicja kolumny Place tabeli ImportGPS4SchoolPOZ

Name

Place

Code

Place

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna AdmCode tabeli ImportGPS4SchoolPOZ

Definicja kolumny AdmCode tabeli ImportGPS4SchoolPOZ

Name

AdmCode

Code

AdmCode

Data Type

VARCHAR2(13)

Mandatory

No

Comment

 


Kolumna PostalCode tabeli ImportGPS4SchoolPOZ

Definicja kolumny PostalCode tabeli ImportGPS4SchoolPOZ

Name

PostalCode

Code

PostalCode

Data Type

VARCHAR2(6)

Mandatory

No

Comment

 


Kolumna Street tabeli ImportGPS4SchoolPOZ

Definicja kolumny Street tabeli ImportGPS4SchoolPOZ

Name

Street

Code

Street

Data Type

VARCHAR2(48)

Mandatory

No

Comment

 


Kolumna HomeNo tabeli ImportGPS4SchoolPOZ

Definicja kolumny HomeNo tabeli ImportGPS4SchoolPOZ

Name

HomeNo

Code

HomeNo

Data Type

VARCHAR2(9)

Mandatory

No

Comment

 


Kolumna FlatNo tabeli ImportGPS4SchoolPOZ

Definicja kolumny FlatNo tabeli ImportGPS4SchoolPOZ

Name

FlatNo

Code

FlatNo

Data Type

VARCHAR2(6)

Mandatory

No

Comment

 


Kolumna StartDT tabeli ImportGPS4SchoolPOZ

Definicja kolumny StartDT tabeli ImportGPS4SchoolPOZ

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna DocLastName tabeli ImportGPS4SchoolPOZ

Definicja kolumny DocLastName tabeli ImportGPS4SchoolPOZ

Name

DocLastName

Code

DocLastName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna DocFirstName tabeli ImportGPS4SchoolPOZ

Definicja kolumny DocFirstName tabeli ImportGPS4SchoolPOZ

Name

DocFirstName

Code

DocFirstName

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna LicenceNo tabeli ImportGPS4SchoolPOZ

Definicja kolumny LicenceNo tabeli ImportGPS4SchoolPOZ

Name

LicenceNo

Code

LicenceNo

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna DocNationalIDNo tabeli ImportGPS4SchoolPOZ

Definicja kolumny DocNationalIDNo tabeli ImportGPS4SchoolPOZ

Name

DocNationalIDNo

Code

DocNationalIDNo

Data Type

VARCHAR2(11)

Mandatory

No

Comment

 


Kolumna CategoryGPID tabeli ImportGPS4SchoolPOZ

Definicja kolumny CategoryGPID tabeli ImportGPS4SchoolPOZ

Name

CategoryGPID

Code

CategoryGPID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StopDT tabeli ImportGPS4SchoolPOZ

Definicja kolumny StopDT tabeli ImportGPS4SchoolPOZ

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna SchoolFullName tabeli ImportGPS4SchoolPOZ

Definicja kolumny SchoolFullName tabeli ImportGPS4SchoolPOZ

Name

SchoolFullName

Code

SchoolFullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna SchoolKindID tabeli ImportGPS4SchoolPOZ

Definicja kolumny SchoolKindID tabeli ImportGPS4SchoolPOZ

Name

SchoolKindID

Code

SchoolKindID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CompanyStatisticalNo tabeli ImportGPS4SchoolPOZ

Definicja kolumny CompanyStatisticalNo tabeli ImportGPS4SchoolPOZ

Name

CompanyStatisticalNo

Code

CompanyStatisticalNo

Data Type

VARCHAR2(14)

Mandatory

No

Comment

 


Kolumna PupilCategoryID tabeli ImportGPS4SchoolPOZ

Definicja kolumny PupilCategoryID tabeli ImportGPS4SchoolPOZ

Name

PupilCategoryID

Code

PupilCategoryID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna isMilitaryServicePlace tabeli ImportGPS4SchoolPOZ

Definicja kolumny isMilitaryServicePlace tabeli ImportGPS4SchoolPOZ

Name

isMilitaryServicePlace

Code

isMilitaryServicePlace

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna isBaseOfPayment tabeli ImportGPS4SchoolPOZ

Definicja kolumny isBaseOfPayment tabeli ImportGPS4SchoolPOZ

Name

isBaseOfPayment

Code

isBaseOfPayment

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna IdentificationTypeID tabeli ImportGPS4SchoolPOZ

Definicja kolumny IdentificationTypeID tabeli ImportGPS4SchoolPOZ

Name

IdentificationTypeID

Code

IdentificationTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna IdentificationDocumentNo tabeli ImportGPS4SchoolPOZ

Definicja kolumny IdentificationDocumentNo tabeli ImportGPS4SchoolPOZ

Name

IdentificationDocumentNo

Code

IdentificationDocumentNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna FluoridePrevention tabeli ImportGPS4SchoolPOZ

Definicja kolumny FluoridePrevention tabeli ImportGPS4SchoolPOZ

Name

FluoridePrevention

Code

FluoridePrevention

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ClassName tabeli ImportGPS4SchoolPOZ

Definicja kolumny ClassName tabeli ImportGPS4SchoolPOZ

Name

ClassName

Code

ClassName

Data Type

VARCHAR2(10)

Mandatory

No

Comment

 


Kolumna InsertDate tabeli ImportGPS4SchoolPOZ

Definicja kolumny InsertDate tabeli ImportGPS4SchoolPOZ

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment